# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models, migrations


class Migration(migrations.Migration):

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='TbOrg',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('org_name', models.CharField(max_length=100)),
                ('parent_id', models.IntegerField(blank=True, null=True)),
                ('create_date', models.DateTimeField()),
                ('org_code', models.CharField(max_length=50)),
                ('cost_code', models.CharField(blank=True, max_length=50, null=True)),
                ('org_desc', models.CharField(blank=True, max_length=500, null=True)),
                ('org_desc2', models.CharField(blank=True, max_length=500, null=True)),
                ('is_active', models.IntegerField()),
                ('org_people', models.IntegerField()),
                ('org_people_all', models.IntegerField()),
            ],
            options={
                'db_table': 'tb_org',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='TbOrgRole',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('name', models.CharField(max_length=100)),
                ('code', models.CharField(blank=True, max_length=50, null=True)),
                ('desc', models.CharField(blank=True, max_length=500, null=True)),
                ('level', models.IntegerField(unique=True)),
                ('create_date', models.DateTimeField()),
            ],
            options={
                'db_table': 'tb_org_role',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='TbUserOrg',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('create_date', models.DateTimeField()),
            ],
            options={
                'db_table': 'tb_user_org',
                'managed': False,
            },
        ),
        migrations.CreateModel(
            name='ExceptionInfo',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('product', models.CharField(max_length=50)),
                ('line', models.CharField(max_length=50)),
                ('station', models.CharField(max_length=50)),
                ('description', models.TextField()),
                ('attendant', models.TextField()),
                ('exception_time', models.CharField(max_length=50)),
                ('username', models.CharField(max_length=50)),
                ('sendTime', models.CharField(max_length=100)),
                ('img', models.CharField(max_length=100)),
                ('status', models.CharField(max_length=10)),
            ],
            options={
                'db_table': 'tb_exception_info',
            },
        ),
        migrations.CreateModel(
            name='GroupInfo',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('group_name', models.CharField(max_length=100)),
                ('member', models.TextField()),
                ('employee_name', models.CharField(max_length=50)),
            ],
            options={
                'db_table': 'tb_group_info',
            },
        ),
        migrations.CreateModel(
            name='MeetingInfo',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('meetingRoom', models.CharField(max_length=50)),
                ('title', models.CharField(max_length=100)),
                ('content', models.TextField()),
                ('attendant', models.TextField()),
                ('inform_time', models.CharField(max_length=50)),
                ('username', models.CharField(max_length=50)),
                ('sendTime', models.CharField(max_length=100)),
                ('status', models.CharField(max_length=10)),
            ],
            options={
                'db_table': 'tb_meeting_info',
            },
        ),
        migrations.CreateModel(
            name='SubscriptionInfo',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('product', models.CharField(max_length=50)),
                ('line', models.CharField(max_length=50)),
                ('station', models.CharField(max_length=50)),
                ('username', models.CharField(max_length=50)),
            ],
            options={
                'db_table': 'tb_subscription_info',
            },
        ),
        migrations.CreateModel(
            name='TbOrgLevel',
            fields=[
                ('level', models.IntegerField(primary_key=True, unique=True, serialize=False)),
                ('level_name', models.CharField(max_length=100)),
                ('level_code', models.CharField(max_length=50)),
                ('id', models.IntegerField(unique=True)),
            ],
            options={
                'db_table': 'tb_org_level',
            },
        ),
        migrations.CreateModel(
            name='TbUser',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('password', models.CharField(max_length=128)),
                ('last_login', models.DateTimeField(blank=True, null=True)),
                ('is_superuser', models.IntegerField()),
                ('username', models.CharField(max_length=30, unique=True)),
                ('first_name', models.CharField(max_length=30)),
                ('last_name', models.CharField(max_length=30)),
                ('email', models.CharField(max_length=254)),
                ('is_staff', models.IntegerField()),
                ('is_active', models.IntegerField()),
                ('date_joined', models.DateTimeField()),
                ('nfc_id', models.CharField(blank=True, db_column='NFC_id', max_length=100, null=True)),
                ('ext', models.CharField(blank=True, max_length=50, null=True)),
                ('short_number', models.CharField(blank=True, max_length=50, null=True)),
                ('mobile_phone', models.CharField(blank=True, max_length=50, null=True)),
                ('head', models.CharField(blank=True, max_length=100, null=True)),
                ('sign', models.CharField(blank=True, max_length=100, null=True)),
                ('entry_date', models.DateField()),
                ('sex', models.CharField(max_length=10)),
            ],
            options={
                'db_table': 'tb_user',
            },
        ),
        migrations.CreateModel(
            name='UserList',
            fields=[
                ('id', models.AutoField(verbose_name='ID', primary_key=True, serialize=False, auto_created=True)),
                ('user_list', models.TextField(blank=True, null=True)),
                ('timeout', models.IntegerField(blank=True, null=True)),
                ('desc2', models.CharField(blank=True, max_length=255, null=True)),
                ('desc3', models.CharField(blank=True, max_length=255, null=True)),
                ('user', models.ForeignKey(null=True, to='tb_info.TbUser', blank=True)),
            ],
            options={
                'db_table': 'tb_user_list',
            },
        ),
    ]
